Electronic Bank Transfer (ACB)

Export Control for ACB's

Once all the data for the processing period has been entered and reconciled, you may do the data export for Electronic Payments to your employees. It will however be necessary to define the Export Control Screen before you will be able to do the export.

 

There are many bank systems that can be used for electronically transferring employee’s salaries/ wages and third party payments.

 

Remember to enter the employees’ bank details on their Basic Employee Information Screens (Payment Details Tab), before selecting to make use of Electronic Bank Transfers (ACB’s).

 

Generic ACB Layout

Available for VIP Premier Payroll.

 

A Generic ACB Layout is available for VIP Premier Payroll.

The Generic Layout allows for the customisation of ACB related fields, allowing for the creation of ACB Layouts not currently catered for by VIP. These fields can then picked up with ODBC, Sage Intelligent Reporting or with the Report Writer, to create an ACB Export File.

 

How to Access the ACB Control Screen

  1. Click on Interfaces.
  2. Click on Export Control.
  3. Click on ACB.
  4. The ACB Interface Control Screen will be displayed.

 

ACB Control Screen

 

 

This screen should already be set up as the VIP Consultant would have defined the fields on this screen upon implementation of your VIP System. If you however need to make changes to the existing setup, follow the steps below.

 

  1. Click in the Bank used for ACB processing Entry Field.
  2. You will be warned that all information for the existing bank will be lost when you change these details and will be asked if you want to continue. Click on <Yes> to make changes to this screen, otherwise click on <No>.
  3. Click on the drop-down arrow for the list of options to be displayed.
  4. Make your selection.
  5. Depending on the option you have chosen, you will be prompted to enter further information that is required by your bank, for example Bank Branch Code, Account Number, User ID, etc.
  6. Complete the necessary details.
  7. Click on <Close>.

 

Export Data for ACB's

Once all the data for the processing period has been entered and reconciled, you may do the Data Export for Electronic Payments.

 

This export is performed on the ACB Export Screen.

 

How to Access the ACB Export Screen

The information on this screen may differ slightly depending on which bank you are using.

 

  1. Click on Interfaces.
  2. Click on Export Data.
  3. Click on ACB.
  4. The ACB Export Screen will be displayed.

 

ACB Export Screen

The information on this screen may differ slightly depending on which bank you are using.

 

 

How to do an ACB Export

1. Complete the fields on the ACB Export Screen:

Field on this Screen Action to be taken?
Special Name for Output File The default name which is displayed here is the name usually used by the bank, but you may alter it if necessary.
Destination Path for Transactions / Drive Letter for Transactions

Click on the <Browse> button to locate the destination path to which the export file must be written.

Select the drive to which the export file must be written, e.g. C for the C drive.

Payment (Action) Date (Default = month end)

The default date is the end-date of the processing period but it may be altered.

When you click on the down-arrow for the Payment (Action) Date field, the Calendar Screen will be displayed, from where you may click on the required date. The current system date is also indicated on this screen.

Amount to be Exported

The default is the Nett Pay Amount. If you want to export a different amount, click on the Selected Amount Radio Button and a list of the Earnings and Deductions which can be exported will be displayed on this screen. The selection for the third party payments, e.g. Garnishees, Insurance companies, etc. is also made on this screen.
Enter the Sort Sequence for the Transactions

The records will be written to the export file in Employee Code sequence, but the sequence may be altered.
Employees to be Extracted

The default is All Employees but you may choose to do the export for employees in specific Pay Points, Categories or Departments.

If you choose one of these options you will be prompted to enter a from and to code, e.g. export from Department X to Department Y.

Only these employees will be included in the export.

Certain banks require certain additional fields during the ACB Export.

These fields default to certain values, but may be altered if required.

Make the relevant selections for these additional fields.

 

2. Once you have made all the relevant selections on this screen, click on <Continue>.

 

3. The Windows Print Setup Screen will be displayed and you have to select the applicable printer.

 

4. As soon as the ACB data for a company has been written to the Export File, its totals will be displayed on screen and you must click on <Continue>.

 

5. A list of the companies in the directory will be displayed. It is possible to create an Export File for multiple companies. Click on the next company for which ACB’s must be exported. You will be prompted to enter your password for that specific company.

 

6. Click on <Continue>, otherwise click on <Close>.

 

Multiple Company exports may be created for Nett Pay as well as third party payments. The companies included in the export must use the same Bank Layout, as defined on the ACB Control Screen.

 

How to Export Third Party Payments

  • The Payee and the Reference Numbers from the Third Party Payment Subscreens, e.g. Garnishees, Insurance Companies, Bonds, etc. are included in these Export Files and on the ACB Audit printouts.
  • From the Selected Amount Screen, you may choose what is to be placed in the Payee Name field where this occurs in the Export Layout and on the ACB Audit printout.

 

The available options are:

  • Institution Name,
  • Employee Name in the format Surname followed by Initials,
  • Employee Code, and
  • Institution Name/Employee Code.